date1; $date2 = $data->date2; $room = $data->room; $chek = $DBcon->prepare("SELECT * FROM rooms WHERE Room_no NOT IN ( SELECT DISTINCT Room_no FROM booking_table WHERE Ar_date <= '$date1' AND Dp_date >= '$date2') ") ; $chek->execute() ; ?> fetch(pdo::FETCH_ASSOC) ) { ?>